package org.springblade.pm.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springblade.pm.entity.PmWeeknote;

import java.util.List;
import java.util.Map;

public interface PmWeeknoteMapper extends BaseMapper<PmWeeknote> {
	/**
	 * 查找自己写的周报
	 * @param map
	 * @return
	 */
	List<Map<String, Object>> selectWeekList(Map<String, Object> map);

	/**
	 * 根据id查询周报详细信息
	 * @param
	 * @return
	 */
	Map<String,Object> selectWeekById(Map<String, Object> params);

	/**
	 * 查找对应权限的项目经理
	 * @param params
	 * @return
	 */
	List<Map<String,Object>> getManager(Map<String,Object> params);

	/**
	 * 操作SQL语言
	 * @param sql
	 * @return
	 */
	List<Map<String,Object>> getSql(String sql);

	/**
	 * 查找同部门下项目经理的周报信息
	 * @param map
	 * @return
	 */
	List<Map<String, Object>> selectWeekDeptId(Map<String, Object> map);


	String selectWeekByProjectId(Integer proId);


}
